The PostgreSQL rule system allows one to define an alternate action to be performed on insertions, updates, or deletions in database tables. Roughly speaking, a rule causes additional commands to be executed when a given command on a given table is executed.
Note: You must be the owner of a table to create or change rules for it.
Rules are managed on the Rules tab of the Table Designer. Just simply click on a rule field for editing. By using the toolbar below, you can create new, edit and delete the selected rule field.
Add Rule
To add a rule
- Open the table in the Table Designer.
- Open the Rules tab.
- Click the
Add Rule from the toolbar.
- Edit rule properties.
Edit Rule
To edit a rule
- Open the table in the Table Designer.
- Open the Rules tab.
- Just simply click on the rule to edit.
Delete Rule
To delete a rule
- Open the table in the Table Designer.
- Open the Rules tab.
- Click the
Delete Rule from the toolbar.
- Confirm deleting in the dialog window.
See also:
Setting Rule Properties